Fields

Descriptions

Filter

Display the filtered data list.

Age: Past Due Days

Display the receivables older than the defined number of days.  

In the Basic Parameter page, Past Due AR Days are setup for the client.

In an Account Debtor Maintenance page, past Due AR Days are displayed for the specific Account Debtors.

Example: Past Due AR Days = 60.

All the debtor invoices with a positive value older than 60 days will be marked as ineligible with a reason Aged: Past Due Days.   

For example,

Debtor: AGE1, Past Due AR days = 60,

Over 60 in summary receivables = $0

Over 90 in summary receivables = $2000.00

Over 120 in summary receivables = $4750.00         

Past dues = $0 + $2000.00 + $4750.00 = $6750.00

Debtor: AGE2, Past Due AR days = 60,

Past dues = $0 +$0 +$100 = $100

The summation of all debtors past dues is considered as ineligible amount for the particular client. The same can be viewed under  Ineligible receivable analysis report page and the ineligible amount can be viewed under ABL →  BBC Review/Input  → Ineligible summary page.

Aged Credit Item

Display the Credit data (or Invoices with negative amounts) older than the defined number of days.

For example, Past Due AR Days = 60.

The debtor invoices with a negative value older than 60 days will be marked as ineligible with a reason Aged Credit Item.   

Payment Term Over  Days

Display the receivables having Due Date age more than defined number of days.

Over Days is setup on the Basic Parameters web page and invoices with Aged: Past Due Days status is excluded during the calculation.

For example, Over Invoice Days is setup as 75.

An Invoice with Invoice date of 10/15/2014 and Due Date of 01/10/2015 is assigned as Over Invoice Days.

Ineligible Customer

Display the invoices with exception of Past Due and Aged Credits Invoices for account debtors and such invoices are ineligible.

You must create User Defined ineligible reason code under Ineligibility Reasons page.

The User Defined ineligible customer should be setup under Account Debtors / Vendors page.

Deferred Revenue

Display the total invoices of an Account Debtor with Invoice Date that is exceeding BBC date.

For example, Account Debtor F has an invoice amount with an invoice date exceeding the BBC date 12/31/2012. The exceeding invoice value = $10,000 with an exceeding date of 01/21/2013. This amount is assigned as Deferred Revenue.  

Cross Aged %

If an Account Debtor’s total Receivable amount is more than its Client's Cross Age %, then all the invoices of the customers are assigned as Cross Aged.

Contra

It compares receivables and payable and considers the least two ineligibles. To calculate Contra ineligible amount, link an Account Debtor and Vendor.

You can setup Contra Link under Contras page.

For Example,  Link an Account Debtor C to Vendor C.  

All the eligible invoices of Account Debtor C is compared with open payable of Vendor C, and least of these 2 amounts are assigned as Contra.

Uninsured

Display the Uninsured Value limitation for the eligible invoice amount of an Account Debtor.

If the eligible invoice amount is greater than Uninsured Value, then the difference amount is uninsured.

You can setup Uninsured Value in the Account Debtors / Vendors web page.

For Example, Account Debtor D has setup an Uninsured Value = $10,000.

An eligible invoice amount for Account Debtor D = $15,000.

In this case, difference amount of $5,000 is assigned as Uninsured.

Excluded

Display calculates exclude amount.

Calculation: Receivable Amount Excluded - Greater of the AR Exclude % of an Account Debtor's Receivables or AR Exclude Value. Whichever Exclude amount is greater than the amount is ineligible amount.

Concentration

If an Account Debtor’s total Receivable amount is more than its Client’s Concentration%, then all invoices of the customer are Ineligible or Cap based on the Concentration % will be calculated, to determine the ineligible amount.

For example, Consider Account Debtor G has eligible Receivables of $30,000. Its client has total receivables amount of $100,000 and Concentration % setup as 25%.

CAP – 25% of $100,000 is 25,000. Difference of Eligible Receivables and Cap amount - $5000 is assigned as Concentration.

EXCLUDE – Since Account Debtor G’s Eligible Receivables is more than $25,000 - Concentration% amount, $30,000 is assigned as Concentration.

Retention

It is the carry forward amount which is not calculated has a part of current BBC ,the retention amount is deposited by the customer.

Exceed Credit Limit

Displays the credit limit for Parent account debtor or standard account debtor. The exceeds limit ineligible is calculated on the remaining balance amount of the customer.

If the remaining eligible > Exceeds Credit Limit, then the difference between credit limit amount and the remaining balance is considered as ineligible.

If the remaining eligible < Exceeds Credit Limit, then the eligible value is considered as Exceeds Credit Limit.

Deductible

Specifies the credit limit for debtors with foreign accounts.

• If the Debtor Eligible balanceDebtor Eligible balanceEligible balance = Debtor balance – Past due
    < Deductible Value, then the Deductible ineligible amount is the debtor eligible balance.

• If the Debtor Eligible Balance > Deductible Value, then the Deductible ineligible value is 0.

• If the Debtor Eligible Balance = Deductible Value, then the Deductible ineligible value is 0.

For more information, refer to Debtor Deductible Ineligible Calculations.pdf